Hi Tom

I agree with you that the behavior is not logic and I wan't expecting this
to happen (I asked a similar question in this list a while ago)

In my case I could solve the SQL error by setting the java connection to
unicode and by making sure all inserts are performed as unicode. Here is
the java code (JBuilder) to set connection to uicode:

Properties properties = new Properties();
properties.setProperty("charSet",
interbase.interclient.CharacterEncodings.UTF8);
connecctoinDescriptor.setProperties(properties);
dbTransparency.setConnection(connecctoinDescriptor);

Regards,

Herbert



|---------+---------------------------->
| | Tomas Michalík |
| | <michalik@proca.c|
| | z> |
| | |
| | 29.01.2002 12:12 |
| | Please respond to|
| | ib-support |
| | |
|---------+---------------------------->

>--------------------------------------------------------------------------------------------------------------------------------------------------|

| |
| To: ib-support@yahoogroups.com |
| cc: |
| Subject: Re: [ib-support] unicode BUG in Firebird (probably inInterBase too) |

>--------------------------------------------------------------------------------------------------------------------------------------------------|

Hi Helen,

Helen Borrie wrote:

>
> Tomas,
> Just for interest's sake, see what happens when you insert this:
>
> insert into tab_country values (_UNICODE_FSS'aaaaaa',

_UNICODE_FSS'bbbbbbbbbbbbbbbb')

It makes no (visible) difference, it just inserts the values without any
complains.

BTW, I might add that reading this via JDBC driver reports an error:
"SQL error code=-303 arithmetic exception, numeric overflow, or string
runcation"

Unfortunately I don't know which driver, what settings etc. as I am not
the one who tried it.

Best regards,
Tom
=================================

Tomas Michalik
ProCA, s. r. o.
V Luzich 818, Praha 4
Czech Republic

e-mail: michalik@...
tel: +420 2 67283446


To unsubscribe from this group, send an email to:
ib-support-unsubscribe@egroups.com



Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/