[SqueakDBX] Problem with Czech characters
Michal Perutka
michal.perutka at gmail.com
Mon Jul 20 10:07:20 UTC 2009
Hi,
I have solved my problem - I installed full Oracle Client (with Czech
language support :), unzipping Oracle Instant Client simply wasn't enough.
*"Did you have any problem?"
*
Yes, I had troubles with building OpenDBX from source (with MinGW and MSYS)
- I couldn't get liboraclebackend-1.dll (and still can't - only
libopendbx-1.dll and libopendbxplus-1.dll). But I solved this by downloading
Windows DLLs from OpenDBX web pages.
Anyway, thank you very much.
Michal
2009/7/19 Mariano Martinez Peck <marianopeck at gmail.com>
>
> On Sat, Jul 18, 2009 at 7:24 PM, 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:
>>
>
> Hi! Welcome to SqueakDBX. We hope we can help you :)
> You say "and finally I was able to get my first result". Did you have any
> problem? We would love to know it so that to fix it or at least to document
> it. We want to make our wiki the most useful possible.
>
>
>
>
>>
>> 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)
>
>
> mmmmm I have a couple of cuestions about this:
>
> 1) The database is also in a Windows? or other OS ?
>
> 2) Can you send me an example of those czech characters ? perhaps a record
> of the user table?
>
> 3) I remember that in Oracle you can specify the encoding of the database.
> which is the encoding of the one you are trying to use?
>
> 4) Can you perfectly send queries and inserts using czech characters using
> a SQL client like sqlplus or SLQDeveloper ?
>
>
>
>>
>> - order of names is bad
>>
>
> This is weird. Cannot do it right now, but in case we don't have a unit
> test for this, I will do it and see if I can reproduce it here. If there is
> a bug, it will be fixed :)
>
>
>>
>> Does SqueakDBX support national character sets and sorting ?
>
>
> Sorting for sure. Perhaps there is a little bug but this is supported.
>
> National character, I have to investigate it a bit. There are several
> "things" here:
>
> - Database support
> - Native C client library support
> - OpenDBX
> - Squeak has a lot of problems with encoding yet
> - SqueakDBX
>
> However, my latin amercian characters like:
>
> 'éçèéçè',
> 'éçèéçèéçèéçè', '
> 'äöüäöü'
> 'äöüäöüäöüäöü'
>
> are working well.
>
> When you answer me your questions I can ask openDBX author and also make
> some tests.
>
> Best,
>
> Mariano
>
>
>
>
>>
>> Michal
>>
>>
>> _______________________________________________
>> SqueakDBX mailing list
>> SqueakDBX at lists.squeakfoundation.org
>> http://lists.squeakfoundation.org/mailman/listinfo/squeakdbx
>>
>>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.squeakfoundation.org/pipermail/squeakdbx/attachments/20090720/fd2220db/attachment.htm
More information about the SqueakDBX
mailing list