Hi Michal,<div>I think that you have an oracle configuration problem. Make sure that your window register have:</div><div><span class="Apple-style-span" style="font-family: Tahoma; font-size: 12px; line-height: 18px; ">NLS_NCHAR_CHARACTERSET UTF8</span></div>
<div><font class="Apple-style-span" face="Tahoma" size="3"><span class="Apple-style-span" style="font-size: 12px; line-height: 18px;">NS_LANG AMERICAN_AMERICA.UTF8</span></font></div><div><font class="Apple-style-span" face="Tahoma" size="3"><span class="Apple-style-span" style="font-size: 12px; line-height: 18px;"><br>
</span></font></div><div><font class="Apple-style-span" face="Tahoma" size="3"><span class="Apple-style-span" style="font-size: 12px; line-height: 18px;">see this site:</span></font></div><div><a href="http://www.orafaq.com/forum/t/54946/0/">http://www.orafaq.com/forum/t/54946/0/</a>  <br>
</div><div><br></div><div><br></div><div><br><div class="gmail_quote">On Sat, Jul 18, 2009 at 19:24, Michal Perutka <span dir="ltr">&lt;<a href="mailto:michal.perutka@gmail.com">michal.perutka@gmail.com</a>&gt;</span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;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>
<br>connectionSettings := DBXConnectionSettings<br>        host: &#39;<a href="http://oracledb2.srs.cz" target="_blank">oracledb2.srs.cz</a>&#39;<br>
        port: &#39;1521&#39;<br>        database: &#39;ISMON&#39;<br>        userName: &#39;xxx&#39;<br>        userPassword: &#39;xxx&#39;.<br><br>conn := DBXConnection<br>        platform: DBXOraclePlatform new<br>        settings: connectionSettings.    <br>

<br>conn connect.<br>conn open.<br>result := conn execute: &#39;select name from users order by name&#39;.<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)<br>

- order of names is bad<br><br>Does SqueakDBX support national character sets and sorting ?<br><font color="#888888"><br>Michal<br><br>
</font><br>_______________________________________________<br>
SqueakDBX mailing list<br>
<a href="mailto:SqueakDBX@lists.squeakfoundation.org">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><br clear="all"><br>-- <br>Germán<br>
</div>