[SqueakDBX] Problem with Czech characters

[Michal Perutka]

Hi,

and thanks. I installed full Oracle Client (with Czech language support) and
now I have in register

NLS_LANG=CZECH_CZECH REPUBLIC.EE8MSWIN1250.

And it works. Of course, in Squeak I have to convert from CP1250.

Michal

2009/7/19 Germán Palacios <gfpalacios at gmail.com>

Hi Michal,I think that you have an oracle configuration problem. Make sure
> that your window register have:
> NLS_NCHAR_CHARACTERSET UTF8
> NS_LANG AMERICAN_AMERICA.UTF8
>
> see this site:
> http://www.orafaq.com/forum/t/54946/0/
>
>
>
> On Sat, Jul 18, 2009 at 19:24, Michal Perutka <michal.perutka at gmail.com>wrote:
>
>> Hello,
>>
>> I started to test SqueakDBX yesterday (Squeak 3.10.2, OpenDBX 1.4.1,
>> Windows XP, Oracle DB) and finally I was able to get my first result set:
>>
>> connectionSettings := DBXConnectionSettings
>>         host: 'oracledb2.srs.cz'
>>         port: '1521'
>>         database: 'ISMON'
>>         userName: 'xxx'
>>         userPassword: 'xxx'.
>>
>> conn := DBXConnection
>>         platform: DBXOraclePlatform new
>>         settings: connectionSettings.
>>
>> conn connect.
>> conn open.
>> result := conn execute: 'select name from users order by name'.
>> DBXTranscript show: result.
>> conn close.
>> conn disconnect.
>>
>> But I have two problems:
>> - all czech characters are converted to ASCII (diacritical marks are
>> removed)
>> - order of names is bad
>>
>> Does SqueakDBX support national character sets and sorting ?
>>
>> Michal
>>
>>
>> _______________________________________________
>> SqueakDBX mailing list
>> SqueakDBX at lists.squeakfoundation.org
>> http://lists.squeakfoundation.org/mailman/listinfo/squeakdbx
>>
>>
>
>
> --
> Germán
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.squeakfoundation.org/pipermail/squeakdbx/attachments/20090720/bc57224a/attachment.htm