Sign in Join

Live chat for Free Pascal, Lazarus, Delphi and every Pascal programmer.

Mailing lists / lazarus / 2015-02

German Umlauts and Oracle Connection

6 messages · 3 people · –

Reply by email Subscribe to this list Your subscription

Read-only archive. Use j and k to move between messages.

John Landmesser

i get Citynames from a oracle Database, but i get for example "Gie?en" instead of "Gie?en" In a TDBGrid.

I tried different Charset in my OracleConnection.Charset as mentioned from Oracle on

http://docs.oracle.com/cd/B28359_01/server.111/b28298/applocaledata.htm#CIAJAGCB

but without success!

If i put a Tedit on my form, i can write "Gie?en", so it has to be a setting in OracleConnection?!!

MainForm.Font.CharSet Is DEFAULT_CHARSET

Tipps are welcome!

( strange: sent this mail from my gmail account today 16:26, but it never arrived?? )

Reply by email

Michael Van Canneyt
to John Landmesser
John Landmesser wrote 9 lines
i get Citynames from a oracle Database, but i get for example "Gie?en" instead of "Gie?en" In a TDBGrid. I tried different Charset in my OracleConnection.Charset as mentioned from Oracle on http://docs.oracle.com/cd/B28359_01/server.111/b28298/applocaledata.htm#CIAJAGCB but without success!

Normally, I'd expect you'd have to specify UTF8 as the charset, since that is what the LCL uses.

Show quoted text 8 lines
If i put a Tedit on my form, i can write "Gie?en", so it has to be a setting in OracleConnection?!! MainForm.Font.CharSet Is DEFAULT_CHARSET Tipps are welcome!

What platform is this ?

If it is linux, did you include cwstring in your program's uses clause ?

Michael.

Reply by email

John Landmesser
to Michael Van Canneyt
Michael Van Canneyt wrote
Normally, I'd expect you'd have to specify UTF8 as the charset, since that is what the LCL uses.

Oracle is on a Windows Server 2003 and my Lazarus Client on a Win XP

I have to try UTF8 tomorrow, when i'm back in office.

Thanks for this tip!!

Reply by email

John Landmesser
to John Landmesser
Michael Van Canneyt wrote
> > > Normally, I'd expect you'd have to specify UTF8 as the charset, since > that is what the LCL uses.

Tried a lot to get OracleConnection working with german special characters like ? ? ? ? but without success.

Then i tried ZeosLib that works out of the box!

I want to figure out how they solve this CodePage thing, but i think thats fare beyond my knowledge :-((

Reply by email

Mattias Gaertner
to John Landmesser
Show quoted text 5 lines
Am 09.02.2015 um 20:37 schrieb Michael Van Canneyt: > > > > > > Normally, I'd expect you'd have to specify UTF8 as the charset, since > > that is what the LCL uses.

SQLDB has "CharSet", but unit oracleconnection does not seem to use it.

Mattias

Reply by email

John Landmesser
to Mattias Gaertner
Mattias Gaertner wrote 9 lines
SQLDB has "CharSet", but unit oracleconnection does not seem to use it. Mattias -- _______________________________________________ Lazarus mailing list http://lists.lazarus.freepascal.org/mailman/listinfo/lazarus

I tried a lot to get OracleConnection working but in vain.

No i use ZeosLib thats working out of the Box.

I want to try to understand how they managed these CodePage thing, but i think thats far beyond my knowledge!

Wondering: if i send a message from my gmail accounjt, it never shown up in this list!??

Reply by email