How to idetify the phonetic alphabets in MS SQL database tables

Question

We have inserted more than 100000 records through Import flat file functionality in sql server management studio. It was inserted successfully. But some of column values contained characters like é and ö . It got converted into while storing in sql column for all above characters like(ö,é).

Moreover the below SQL statements is not giving any results.

select * from Temp where column1 like '%%'

The data with these characters in the tables are being displayed with a symbol(question mark in a diamond).

Please help as to how can I insert the data keeping the phoentic symobols intact.

Can you give a few example of data of the import file and the data you have now on MS SQL? — Francesco Mantovani, Dec 19 '19 at 07:45
Also please give the definition of the table you inserted into. — AakashM, Dec 19 '19 at 09:26
Hi @FrancescoMantovani. Möller in the file is M�ller in the database — ssuhas76, Dec 19 '19 at 09:53

score 1 · Accepted Answer · answered Dec 19 '19 at 08:38

Your data contains some characters like é and ö. But when you see in the database, it's stored "?" instead of that, right?

I think, your database does not support all characters. I would recommend to change it to something like this:

character set: utf8
collation: utf8_general_ci

Hope to help, my friend :))

score 0 · Answer 2 · answered Dec 19 '19 at 09:55

0

character set: utf8 collation: utf8_general_ci

answered Dec 19 '19 at 09:55

ssuhas76

83
1
12

score -1 · Answer 3 · answered Dec 19 '19 at 09:24

-1

SELECT 
 * 
FROM TEMP 
WHERE SOUNDEX(COLUMN1) LIKE SOUNDEX('A')

strong text

answered Dec 19 '19 at 09:24

Mithun ambadi

1
2

How to idetify the phonetic alphabets in MS SQL database tables

3 Answers3