# TDA automation encoding problem **URL:** \ **Category:** Toad Data Point & Toad Intelligence Central\ **Created:** [August 17, 2011, 7:59am UTC](https://forums.toadworld.com/t/tda-automation-encoding-problem/6806 "2011-08-17T07:59:05Z")\ **Posts on this page:** 15\ **Page:** 1
**Author:** ![bobrovskyaa\_718](https://avatars.discourse-cdn.com/v4/letter/b/bc79bd/32.png) [@bobrovskyaa\_718](https://forums.toadworld.com/u/bobrovskyaa_718)\ **Post date:** [August 17, 2011, 7:59am UTC](https://forums.toadworld.com/t/tda-automation-encoding-problem/6806/1 "2011-08-17T07:59:05Z")
Automation does not pay attention to encoding. So all i see is a bunch of question marks in my result set exported to excel sheet. However i have never encountered with the problem in editor. All works fine. My NLS\_LANG is RUSSIA.CIS\_CL8MSWIN1251. Hope there’s a chance to solve a problem and not to use decode or something in my queries. ---
**Author:** ![Debbie\_Peabody](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/debbie_peabody/32/18_2.png) [@Debbie\_Peabody](https://forums.toadworld.com/u/Debbie_Peabody)\ **Post date:** [August 17, 2011, 11:46am UTC](https://forums.toadworld.com/t/tda-automation-encoding-problem/6806/2 "2011-08-17T11:46:02Z")
Interesting problem. Can you right clcik on the editor and send me a screen shot showing the Character encoding? It is a sub menu down near the bottom on the right click of the editor. Also, once connected to Oracle, go to the Tools | Administrator | Session Info. Go to the NLS Parameters tab and take a full screenshot. This tells me the NLS Parms for client, server, and session. Thirdly, can you attach a sample excel file? We have a whole team in Russia that uses TDA and does not have issues, so perhaps we can find a work around. Debbie ---
**Author:** ![IgorM](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/igorm/32/116_2.png) [@IgorM](https://forums.toadworld.com/u/IgorM)\ **Post date:** [August 17, 2011, 11:49am UTC](https://forums.toadworld.com/t/tda-automation-encoding-problem/6806/3 "2011-08-17T11:49:03Z")
Can you please try and make sure that “direct” export without Automation works fine? Thanks, Igor. ---
**Author:** ![bobrovskyaa\_718](https://avatars.discourse-cdn.com/v4/letter/b/bc79bd/32.png) [@bobrovskyaa\_718](https://forums.toadworld.com/u/bobrovskyaa_718)\ **Post date:** [August 18, 2011, 6:59am UTC](https://forums.toadworld.com/t/tda-automation-encoding-problem/6806/4 "2011-08-18T06:59:19Z")
The character encoding in editor is "cyrillic (Windows)". Result set outputs properly in editor as you can see on screenshot. Also I attach screenshot of nls\_parameters and excel file taken from the automation process. ![nls_parameters.jpeg](https://global.discourse-cdn.com/quest/original/2X/5/511f863383edac35b970d06ff6e12d69e7d4ab48.jpeg) ---
**Author:** ![bobrovskyaa\_718](https://avatars.discourse-cdn.com/v4/letter/b/bc79bd/32.png) [@bobrovskyaa\_718](https://forums.toadworld.com/u/bobrovskyaa_718)\ **Post date:** [August 18, 2011, 6:59am UTC](https://forums.toadworld.com/t/tda-automation-encoding-problem/6806/5 "2011-08-18T06:59:19Z")
The character encoding in editor is “cyrillic (Windows)”. Result set outputs properly in editor as you can see on screenshot. Also I attach screenshot of nls\_parameters and excel file taken from the automation process. [sample\_file.xls](https://global.discourse-cdn.com/quest/original/2X/5/58768d09823e7ef7f39ca4f8912ae9e50b4a52d5.xls) (11 KB) ---
**Author:** ![bobrovskyaa\_718](https://avatars.discourse-cdn.com/v4/letter/b/bc79bd/32.png) [@bobrovskyaa\_718](https://forums.toadworld.com/u/bobrovskyaa_718)\ **Post date:** [August 18, 2011, 6:59am UTC](https://forums.toadworld.com/t/tda-automation-encoding-problem/6806/6 "2011-08-18T06:59:19Z")
The character encoding in editor is "cyrillic (Windows)". Result set outputs properly in editor as you can see on screenshot. Also I attach screenshot of nls\_parameters and excel file taken from the automation process. ![editor.jpeg](https://global.discourse-cdn.com/quest/original/2X/4/405080df3e74d2ebf6573fd9c92a30a375900ab0.jpeg) ---
**Author:** ![Debbie\_Peabody](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/debbie_peabody/32/18_2.png) [@Debbie\_Peabody](https://forums.toadworld.com/u/Debbie_Peabody)\ **Post date:** [August 18, 2011, 3:46pm UTC](https://forums.toadworld.com/t/tda-automation-encoding-problem/6806/7 "2011-08-18T15:46:55Z")
I entered CR89780 on this issue. Let me investigate and see if there is a work around. Debbie ---
**Author:** ![bobrovskyaa\_718](https://avatars.discourse-cdn.com/v4/letter/b/bc79bd/32.png) [@bobrovskyaa\_718](https://forums.toadworld.com/u/bobrovskyaa_718)\ **Post date:** [August 18, 2011, 4:24pm UTC](https://forums.toadworld.com/t/tda-automation-encoding-problem/6806/8 "2011-08-18T16:24:13Z")
Thanks for your help. One thing I forgot to add, NLS\_LANG in Oracle DB taken from the V$NLS\_PARAMETERS VIEW is RUSSIAN\_CIS.AL16UTF16. In Tools --\> Session tab it’s AMERICAN\_AMERICA.AL16UTF16. Message was edited by: bobrovskyaa\_718 ---
**Author:** ![Debbie\_Peabody](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/debbie_peabody/32/18_2.png) [@Debbie\_Peabody](https://forums.toadworld.com/u/Debbie_Peabody)\ **Post date:** [August 18, 2011, 6:22pm UTC](https://forums.toadworld.com/t/tda-automation-encoding-problem/6806/9 "2011-08-18T18:22:24Z")
I noticed that I can reproduce the issue if I use a SQL file that is not saved as a unicode text file. If I save the file as a unicode file, automatio works correctly. Can you check to see that the \*.sql file is saved as unicode? If you copy and paste the SQL into a new editor and save from with in TDA, it will ask you if you want to save it as unicode. Debbie ---
**Author:** ![bobrovskyaa\_718](https://avatars.discourse-cdn.com/v4/letter/b/bc79bd/32.png) [@bobrovskyaa\_718](https://forums.toadworld.com/u/bobrovskyaa_718)\ **Post date:** [August 19, 2011, 4:11am UTC](https://forums.toadworld.com/t/tda-automation-encoding-problem/6806/10 "2011-08-19T04:11:58Z")
Yes, SQL file must be save in Unicode. Thank you very much for solution. It will be nice if TDA converted SQL in Unicode automatically on Add to Project. ---
**Author:** ![Alexander.Maximov](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/alexander.maximov/32/114_2.png) [@Alexander.Maximov](https://forums.toadworld.com/u/Alexander.Maximov)\ **Post date:** [August 19, 2011, 4:41am UTC](https://forums.toadworld.com/t/tda-automation-encoding-problem/6806/11 "2011-08-19T04:41:12Z")
> It will be nice if TDA converted SQL in Unicode automatically on Add to Project. > Toad asks about changing encoding on savng sql from Editor. See attached. In your case - you have to convert all your files with any text tool that supports such conversions or by re-saving each sql file in TDA. good luck! ![saveUnicode.png](https://global.discourse-cdn.com/quest/original/2X/4/439dbb088bd354128cc5c9c9f1f9f7afa4c96233.png) ---
**Author:** ![bobrovskyaa\_718](https://avatars.discourse-cdn.com/v4/letter/b/bc79bd/32.png) [@bobrovskyaa\_718](https://forums.toadworld.com/u/bobrovskyaa_718)\ **Post date:** [August 19, 2011, 4:54am UTC](https://forums.toadworld.com/t/tda-automation-encoding-problem/6806/12 "2011-08-19T04:54:11Z")
> Toad asks about changing encoding on savng sql from Editor. See attached. > Toad asks if you write sql in editor. I've just opened sql files and had not this warning from toad. ---
**Author:** ![Alexander.Maximov](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/alexander.maximov/32/114_2.png) [@Alexander.Maximov](https://forums.toadworld.com/u/Alexander.Maximov)\ **Post date:** [August 19, 2011, 5:04am UTC](https://forums.toadworld.com/t/tda-automation-encoding-problem/6806/13 "2011-08-19T05:04:47Z")
But how it reacts when you save the file? I suppose you have to place at least empty space to enable saving action though. ---
**Author:** ![bobrovskyaa\_718](https://avatars.discourse-cdn.com/v4/letter/b/bc79bd/32.png) [@bobrovskyaa\_718](https://forums.toadworld.com/u/bobrovskyaa_718)\ **Post date:** [August 19, 2011, 5:07am UTC](https://forums.toadworld.com/t/tda-automation-encoding-problem/6806/14 "2011-08-19T05:07:57Z")
I open some sql files and then add to project them. That’s all. All I have to do is to pick up them in automation. ---
**Author:** ![Alexander.Maximov](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/alexander.maximov/32/114_2.png) [@Alexander.Maximov](https://forums.toadworld.com/u/Alexander.Maximov)\ **Post date:** [August 19, 2011, 6:08am UTC](https://forums.toadworld.com/t/tda-automation-encoding-problem/6806/15 "2011-08-19T06:08:29Z")
Right, but as I see for now you have some issues with it. So you have to apply a workaround (re-save with unicode) to work it out.