Stream Read - Multi Languages

Question

Question

Ihsan Ahmed · Jun 28, 2020

Hi, I am doing a stream read so that I can do some inserts to the table however other language read is not supported, any idea what I need to do to achieve this?

Thanks

Discussion (4)0

Log in or sign up to continue

Eduard Lebedyuk · Jun 28, 2020

If it's a File Stream you can set TranslateTable property to your charset before reading.

Otherwise you can use $zcvt function to convert strings.

Here's an example of iterating encodings for $zcvt to determine a correct encoding.

If you are interested in encoding internals use zzdump to check hexdumps.

If your encoding is region specific don't forget to set your locale.

0 0

score 0 · Answer 1 · 2020-06-28T05:29:00-04:00

Evgeny Shvarov · Jun 28, 2020

Not sure what doesn't work for you. Could you please share an example? Or elaborate the problem?

0 0

score 0 · Answer 2 · 2020-06-28T05:33:35-04:00

Hi, Thank you for your response.. I am writing a routine to upload some data to the table, the language I am looking to upload the data is actually arabic, but it inserts gibrish.. any idea how I could support Arabic inserts.. if i insert directly through the DBMS Inserts.. it goes through perfectly... so this is something to do with the reads of the file...any help in this is greatly appreciated.

score 0 · Answer 3 · 2020-06-28T07:18:57-04:00

Ihsan Ahmed · Jun 28, 2020

great, it worked... did the below

Do stream.TranslateTableSet(“UTF8”).

Thanks

0 0