Problems with special character�s (umlaut)

Thread View: borland.public.interbase.sql

5 messages

[T] Back to Threads [V] Tree View [G] Group Articles

5 total messages Started by Heiko Tue, 17 Dec 2002 14:53

#11044

Author: Heiko
Date: Tue, 17 Dec 2002 14:53

16 lines
1357 bytes

Hello,

i have a problem with the interbase db (VB - ADO)
If i try to update a text with umlauts, so i get alway the error:

Arithmetic exception, numeric overflow, or string truncation
Cannot transliterate character between character sets
Statement: update artikel
set arttext="SV 3528 W�scheschleuder"
WHERE artikelnr="3949398"

How can i fix the problem?


Thanks,
Heiko

Re: Problems with special character�s (umlaut)

#11045

Author: Rolf Bredemeier
Date: Tue, 17 Dec 2002 16:35

6 lines
1273 bytes

Heiko,

you have to use the correct charset for the DB-connection.
The charset WIN1252 should do it...

Best regards, Rolf

Re: Problems with special character�s (umlaut)

#11047

Author: Heiko
Date: Tue, 17 Dec 2002 17:14

29 lines
1679 bytes

Hello,

i try it in VB, but get the same error.

My Connectionstring:
----------------------
Provider=MSDASQL.1;Password=xxx;User ID=xxx;Data
Source=GDI;Mode=ReadWrite;Extended
Properties="DSN=GDI;UID=xxx;PWD=xxx;character
set=WIN1252;DB=video-opti:C:\GDILine\Test-bcc\Gdi.gdb"


SQL:
-------------------
UPDATE
        artikel
SET
        steuerek=27, steuervk=3, aenddatum='17.12.02 18:08:36',
aendbed='VB', arttext='He�DDLT 18 DURCHLAUFERH.'
WHERE
        artikelnr='ep0010080'



And i try it in the IBConsole, same error.
Do you have an example Script?

Cheers
Heiko

Re: Problems with special character�s (umlaut)

#11053

Author: Craig Stuntz TeamB
Date: Tue, 17 Dec 2002 18:21

15 lines
1617 bytes

In article <atnjpd$3bf$02$1@news.t-online.com>, rbredemeier@laweco.de 
says...
> you have to use the correct charset for the DB-connection.
> The charset WIN1252 should do it...
> 
	Also, the charset for the connection should match the charset for 
the column, unless you have a specific reason not to do this.

	-Craig

-- 
Craig Stuntz [TeamB] � Vertex Systems Corp. � Columbus, OH
Delphi/InterBase Weblog : http://delphi.weblogs.com
InterBase Perf. Monitor : http://delphi.weblogs.com/IBPerformanceMonitor
InterBase PLANalyzer 1.1: http://delphi.weblogs.com/IBPLANalyzer

Re: Problems with special character�s (umlaut)

#11079

Author: Heiko
Date: Fri, 20 Dec 2002 16:24

27 lines
1642 bytes

Hello,

now i have found the problem.
I vorget to insert in the DSN ODBC the charset. Now it works :-)

Cheers Heiko

"Heiko" <hpriebe@vsh-online.com> schrieb im Newsbeitrag
news:3dff3a84@newsgroups.borland.com...
> Hello,
>
> i have a problem with the interbase db (VB - ADO)
> If i try to update a text with umlauts, so i get alway the error:
>
> Arithmetic exception, numeric overflow, or string truncation
> Cannot transliterate character between character sets
> Statement: update artikel
> set arttext="SV 3528 W�scheschleuder"
> WHERE artikelnr="3949398"
>
> How can i fix the problem?
>
>
> Thanks,
> Heiko
>
>

Thread Navigation

This is a paginated view of messages in the thread with full content displayed inline.

Messages are displayed in chronological order, with the original post highlighted in green.

Use pagination controls to navigate through all messages in large threads.

Back to All Threads