Issue 69270

Summary: German Umlauts in postgresql table mangled
Product: Base Reporter: rkollien <rudolf.kollien>
Component: codeAssignee: dbaneedsconfirm <needsconfirm>
Status: CLOSED IRREPRODUCIBLE QA Contact: issues@dba <issues>
Severity: Trivial    
Priority: P4 CC: issues
Version: OOo 2.0.3Keywords: needmoreinfo
Target Milestone: ---   
Hardware: PC   
OS: Linux, all   
Issue Type: DEFECT Latest Confirmation in: ---
Developer Difficulty: ---

Description rkollien 2006-09-05 12:08:16 UTC 
I access a table in a postgresql database via the unixODBC driver. Some cells in
the table contain values with german Umlauts (ä,ö,ü....). When i use the
datasource with OOo 2.0.3, than the Umlauts geht mangled (seems they are
represented as a "double-character"). When accessing the postgresql table with
other tools like knoda, rekall or pgaccess, the characters are displayed
correctly. All OOo components (Writer, Base, Calc) show invalid characters.
Unfortunately unlike in version 1.1.x of OOo, in the 2.x there is no "Character
Set" option in the datasource dialog any more.

Just to be sure: i speak from the content of a cell, not the row headers!
Comment 1 rkollien 2006-10-16 17:54:02 UTC 
After a long journey through the options in base i found the character set
option. Not very user friendly, but existent.
Comment 2 christoph.lukasiak 2006-10-23 14:46:33 UTC 
clu->rkollien: 1. does that fix your problem? 2. if you miss any info in the
help or find dialogues not good usuable or pretty hidden, please write issues /
feature enhancements for such cases to improve the oo (it will also help others)

thx
Comment 3 rkollien 2006-10-23 15:08:17 UTC 
1. Yes, this solves my problem.
2. Now in 2.0.4 i found the "characterset" keyword ("Zeichensatz" in the german
translation). Now this is ok too. Great work at all.