[SqueakDBX] Problem with Czech characters

[Germán Palacios]

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/20090719/7d083d2a/attachment.htm