Ctd15 mysql nls-characterset

[Jsfmllr]

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]

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