[SqueakDBX] Problem with Czech characters

[Mariano Martinez Peck]

On Mon, Jul 20, 2009 at 8:50 AM, Michal Perutka <michal.perutka at gmail.com>wrote:

> Hi,
>
> I have solved my problem - I installed full Oracle Client (with Czech
> language support :), unzipping Oracle Instant Client simply wasn't enough.


Michal: I am glad you solved the problem :)


>
>
> *"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).


I am interesting to know which is the real problem. I mean, a lot of people
want to use dll directly as you finally did but I want to identify the
problems when compiling.

If you read this link: http://wiki.squeak.org/squeak/6129   and this:
http://www.assembla.com/spaces/Proyecto-Proyecto/documents/cW1J8Mx40r3Rq-eJe5afGb/download/openDBXtutorial_v2.0.pdf

you will se that in the pdf I describe all the things I did to compile
Oracle. If you have a couple of minutes, could you try it?

If it doesn't work, can you tell which was the problem? For what you said I
imagined you could do ./configure, make and make install but the
liboraclebackend-1.dll wasn't generated.
If this is the case, send us the output of ./configure, make and make
install.

Thanks!

Mariano



> 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/4d14dfc5/attachment.htm