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
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
Who is online
Users browsing this forum: [Ccbot] and 0 guests