<br><div class="gmail_quote">On Mon, Jul 20, 2009 at 8:50 AM, Michal Perutka <span dir="ltr"><<a href="mailto:michal.perutka@gmail.com" target="_blank">michal.perutka@gmail.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
Hi, <br><br>I have solved my problem - I installed full Oracle Client (with Czech language support :), unzipping Oracle Instant Client simply wasn't enough.</blockquote><div><br>Michal: I am glad you solved the problem :)<br>
</div><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;"><div><br><br><i>"Did you have any problem?"<br></i><br></div>
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). </blockquote><div><br>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.<br>
<br>If you read this link: <a href="http://wiki.squeak.org/squeak/6129" target="_blank">http://wiki.squeak.org/squeak/6129</a> and this: <a href="http://www.assembla.com/spaces/Proyecto-Proyecto/documents/cW1J8Mx40r3Rq-eJe5afGb/download/openDBXtutorial_v2.0.pdf" target="_blank">http://www.assembla.com/spaces/Proyecto-Proyecto/documents/cW1J8Mx40r3Rq-eJe5afGb/download/openDBXtutorial_v2.0.pdf</a> <br>
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?<br><br>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.<br>
If this is the case, send us the output of ./configure, make and make install.<br><br>Thanks!<br><br>Mariano<br><br> </div><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
But I solved this by downloading Windows DLLs from OpenDBX web pages.<br><br>Anyway, thank you very much.<br><br>Michal<br><br><div class="gmail_quote">2009/7/19 Mariano Martinez Peck <span dir="ltr"><<a href="mailto:marianopeck@gmail.com" target="_blank">marianopeck@gmail.com</a>></span><div>
<div></div><div><br>
<blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;"><br><br><div class="gmail_quote"><div>On Sat, Jul 18, 2009 at 7:24 PM, Michal Perutka <span dir="ltr"><<a href="mailto:michal.perutka@gmail.com" target="_blank">michal.perutka@gmail.com</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
Hello,<br><br>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:<br></blockquote></div><div><br>Hi! Welcome to SqueakDBX. We hope we can help you :)<br>
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.<br> </div>
</div></blockquote><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;"><div class="gmail_quote"><div><br> </div><div>
<blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;"><br>connectionSettings := DBXConnectionSettings<br> host: '<a href="http://oracledb2.srs.cz" target="_blank">oracledb2.srs.cz</a>'<br>
port: '1521'<br> database: 'ISMON'<br> userName: 'xxx'<br> userPassword: 'xxx'.<br><br>conn := DBXConnection<br> platform: DBXOraclePlatform new<br> settings: connectionSettings. <br>
<br>conn connect.<br>conn open.<br>result := conn execute: 'select name from users order by name'.<br>DBXTranscript show: result.<br>conn close.<br>conn disconnect.<br><br>But I have two problems:<br>- all czech characters are converted to ASCII (diacritical marks are removed)</blockquote>
</div><div><br>mmmmm I have a couple of cuestions about this:<br><br>1) The database is also in a Windows? or other OS ?<br><br>2) Can you send me an example of those czech characters ? perhaps a record of the user table?<br>
<br>
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?<br><br>4) Can you perfectly send queries and inserts using czech characters using a SQL client like sqlplus or SLQDeveloper ?<br>
<br> </div><div><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;"><br>
- order of names is bad<br></blockquote></div><div><br>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 :)</div>
</div></blockquote><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;"><div class="gmail_quote"><div>
<br></div><div><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;"><br>Does SqueakDBX support national character sets and sorting ?</blockquote>
</div><div><br>
Sorting for sure. Perhaps there is a little bug but this is supported.<br><br>National character, I have to investigate it a bit. There are several "things" here:<br><br>- Database support<br>- Native C client library support<br>
- OpenDBX<br>- Squeak has a lot of problems with encoding yet<br>- SqueakDBX<br><br>However, my latin amercian characters like:<br><br>'éçèéçè', <br> 'éçèéçèéçèéçè', ' <br>'äöüäöü'<br>'äöüäöüäöüäöü'<br>
<br>are working well.<br><br>When you answer me your questions I can ask openDBX author and also make some tests. <br><br>Best,<br><br>Mariano<br><br><br><br></div><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
<br><font color="#888888"><br>Michal<br><br>
</font><br>_______________________________________________<br>
SqueakDBX mailing list<br>
<a href="mailto:SqueakDBX@lists.squeakfoundation.org" target="_blank">SqueakDBX@lists.squeakfoundation.org</a><br>
<a href="http://lists.squeakfoundation.org/mailman/listinfo/squeakdbx" target="_blank">http://lists.squeakfoundation.org/mailman/listinfo/squeakdbx</a><br>
<br></blockquote></div><br>
</blockquote></div></div></div><br>
</blockquote></div><br>