Print Thread
Page 2 of 2 1 2
Re: Problem with Character set for special Characters
IvanZ #48183 11/14/13 11:20 AM
Joined: Sep 2009
Posts: 197
Krakow, Poland
Member
Offline
Member
Joined: Sep 2009
Posts: 197
Krakow, Poland
You are right, that you may have loads of problems when writing data (and code) to DB because you will loose what is outside DB encoding. That's exactly what is already happening to DaveE, so that will not be a new problem for him. Also if you keep in mind that you have to stick to only those characters that can be handled by DB (for example Cyrillic and basic Latin characters in my case, and Windows-1252 in case of DaveE), the problem does not have such a big impact on you work.
Anyway I should have warned DaveE of those risks and did not, so am grateful that you did. Thank you.

Re: Problem with Character set for special Characters
IvanZ #48197 11/18/13 09:36 AM
Joined: Nov 2013
Posts: 8
Birmingham, United Kingdom
D
DaveE Offline OP
Member
OP Offline
Member
D
Joined: Nov 2013
Posts: 8
Birmingham, United Kingdom
IvanZ / Hilarion,

Thank you both for your responses.

Unfortunately, turning back on Unicode support and launching it with NLS_LANG environment variable set, did not work either.

For the time been, I will be using the workaround IvanZ suggested, using the chr(172) representation.

Hopefully, somebody from Allround Automations will be able to comment on whether this will be addressed for future releases.

Thanks again for your help,
Dave


Page 2 of 2 1 2

Moderated by  support 

Link Copied to Clipboard
Powered by UBB.threads™ PHP Forum Software 7.7.4
(Release build 20200307)
Responsive Width:

PHP: 7.1.33 Page Time: 0.032s Queries: 15 (0.010s) Memory: 2.5201 MB (Peak: 3.0405 MB) Data Comp: Off Server Time: 2024-05-16 02:15:53 UTC
Valid HTML 5 and Valid CSS