Traditional Chinese Chacterstic shows question mark in SQL Input Preview

Hi Alteryx Expert,

I have one strange issue for input data from SQL

I have one SQL database which is 2008 and it stored data for traditional Chinese characteristic

I need to export some table result from this Chinese SQL to another via Alteryx

What I notice is when I create input data for that Chinese SQL and preview data, all traditional Chinese showing question mark

Even I tried codepage conversation function but result is still in question mark

What I have done so far is

1. install traditional Chinese language pack in my laptop and result is still wrong

2. upload CSV file with result manually export from the SQL and it looks fine in Alteryx

3. run the in-DB function but result is still same

Please let me know how to resolve this

Database Connection

Accepted answers

Yzy

Hi All,

May I know your comment?

One thing i notice is that if we run the SQL code in SSMS, it shows correct Chinese characteristic

Best regards

Alex yang

SeanAdams

Hey @Alex_yang and @Yzy

Are you bringing these into a string field as v_string? This may be the problem, since you need to use V_WString to support the extended character set.

Alternatively, if you're still stuck, then are you able to post a few things to help debug this quickly:

- A simple table create script of 1 or 2 columsn in SQL

- an insert statement to insert a row into this table with the requried characters

- and then just confirmation of the outcome you are looking for (I think you're just looking to copy the data from one table to another?)

thank you

Sean

All comments

Yzy

Hi All,

May I know your comment?

One thing i notice is that if we run the SQL code in SSMS, it shows correct Chinese characteristic

Best regards

Alex yang

SeanAdams

Hey @Alex_yang and @Yzy

Are you bringing these into a string field as v_string? This may be the problem, since you need to use V_WString to support the extended character set.

Alternatively, if you're still stuck, then are you able to post a few things to help debug this quickly:

- A simple table create script of 1 or 2 columsn in SQL

- an insert statement to insert a row into this table with the requried characters

- and then just confirmation of the outcome you are looking for (I think you're just looking to copy the data from one table to another?)

thank you

Sean

Quick Links

This months top contributors

mceleavey 382

LanisC 335

hhaigh1 280

erich_shiino 280

FláviaB 262