Ctd15 mysql nls-characterset

General discussion forum about all databases other than SqlBase.
Jsfmllr
Germany
Posts: 66
Joined: 17 Nov 2019, 16:08
Location: Munich

Ctd15 mysql nls-characterset

Post by Jsfmllr » 20 Apr 2011, 11:16

Hello,

how can i insert german mutated vowels ( ä ö ü ß ) into mysql?
i have some CSV-files, where those german-specific-characters arfe handled correctly.
i read the CSV with my ctd15-application , process some converting and then SqlInsert.
What do i have to set in mySql : collation / ...
what do i have to set in my ctd15-application? nls_characterset / dbp-parameters ?

until now, i tried collation = utf8_general_ci ; but strings are truncated at the first german-specific-character

and i tired collation = latin1_german_ci ; but german-specific-characters are changed to QUESTIONMARK.

Thanx in advance

Sepp

Jsfmllr
Germany
Posts: 66
Joined: 17 Nov 2019, 16:08
Location: Munich

Re: Ctd15 mysql nls-characterset

Post by Jsfmllr » 21 Apr 2011, 07:51

hello ng,

i think i found out the solution by myself: througout all windows in phpmyadmin ( import / export / settings for localhost-databases-tables / ...) there are some comboboxes to select a collation or language. in all these, i select "latin1_german_ci" ... and all german vowels are displayed correctly.
now i will go through the whole process and - hopefully - all will be good at the end

so long
Sepp

Return to “General Discussion”

Who is online

Users browsing this forum: [Ccbot] and 0 guests