Ask a Question related to IBM DB2, Design and Development.
-
Gizmo #1
Problems with special german characters
Hello!
I have got a little problem with DB2 Enterprise Edition Version 8.1.0
for Linux when entering special german characters as ß or ä, ö, ü
(I hope they will appear correctly in this message :-)
First, whenn entering a "ß" within a string there is no problem, but
when this character appears at the end befor the quote I get an error
message telling a quote is missing. I got a workaround by adding a
blank at the end of every string ending with a "ß"
Second I also get error messages when inserting strings containing
umlauts like "ä", "ü". "ö" but teh strange thing is, I could not find
any rule when an error appears and when not. I am only sure that it
has to do with the umlauts.
It always say something like there is a quote missing
I already tried using an extra quote or a backslash "\" but that did
not work.
As I am very new to DB2 I am happy about every hint I get from you.
Thank you in advance.
Below you will find two different error messages as examples:
----------------------
DB21034E The command was processed as an SQL statement because it was
not a
valid Command Line Processor command. During SQL processing it
returned:
SQL0010N The string constant beginning with "',0,'','')" does not have
an
ending string delimiter. SQLSTATE=42603
-----------------------
DB21034E The command was processed as an SQL statement because it was
not a
valid Command Line Processor command. During SQL processing it
returned:
SQL0007N The character "ü" following "Coburg.de','Viele Gr" is not
valid.
SQLSTATE=42601
Gizmo Guest
-
Special characters
I remember seeing an issue with special characters with MX. I'm getting returned '?' when I'm trying to see the character '?' and others. Has anyone... -
Need to insert German characters regularly
In one of the earlier versions of DW, I was able to set-up a new tab in the toolbar at the top, to insert custom special characters from the... -
UCase and German characters
Environment: CFMX- Oracle-Windows XP I'm querying my database for records that matched the German character "?" (If you dont see this character... -
file i/o with german characters
I'm using the file i/o xtra to import text with German characters. The german characters display as ascii garbage. If I take the same file and copy... -
Special Characters - Mac vs. PC - Help
Hi, im developing an hybrid application in director. The application is running very well in PC and MAC, but there is a problem annoying me. I...



Reply With Quote

