Hi Franz



I am a little puzzled as to how you can search for the character ‘o’ in
an Integer column but I have just gone through a session of problems
which

All gave the same ‘cannot transliterate char between charsets’ message.

Make sure that you have set the character set in the client program to
the same one as the server. Check the client has the correct character
set for the Server.



Niall R Scott

IS Support

Cameron Controls

Aberdeen

scottn@...



****************************************************
This e-mail is confidential, may contain proprietary information of the
Cooper Cameron Corporation and its operating Divisions and may be
legally privileged.
This e-mail should be read, copied and/or used only by the addressee. If
you have received this message in error please delete it, together with
any attachment(s), from your system.
****************************************************

-----Original Message-----
From: zipzipziping <zipzipziping@...>
[mailto:zipzipziping@...]
Sent: 29 December 2002 20:22
To: ib-support@yahoogroups.com
Subject: [ib-support] cannot transliterate char between char sets with
äöü in containing for integer



hi,

i have small problems with a select statement.
select * from PARTNER where NR containing 'o' or NAME containing 'o'..
NR is a Integer Column
o is a runtime user value for search PARTNERS
the above statemant works fine
but now if the user uses a spezial german char like ö
select * from PARTNER where NR containing 'ö' or NAME containing 'ö'..
the statement fails with the message
cannot transliterate char between charsets

oh connection is correct with the right charset

if using containing only on varchar columns everything works fine

thanks for your help
franz bartlechner


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



Your use of Yahoo! Groups is subject to the Yahoo!
<http://docs.yahoo.com/info/terms/> Terms of Service.



[Non-text portions of this message have been removed]