0

How can my mysql query change Şarapçı Çağ to Sarapci-Cag

I tried this:

SELECT CONVERT('Şarapçı Çağ' USING latin1) -> ?arapç? Ça?

What can I do?

llanato
  • 2,436
  • 6
  • 35
  • 57
ZeQ
  • 7
  • 1
  • 5

1 Answers1

0

after getting the result you can change like:

"ş","ţ","ă" by "s","t","a" using str_replace.

or you can visit here:PHP converting special characters, like ş to s, ţ to t, ă to a

Community
  • 1
  • 1
Suchit kumar
  • 11,638
  • 3
  • 18
  • 43
  • Is there any way to change on query. – ZeQ Aug 26 '14 at 10:02
  • I try SELECT REPLACE( REPLACE( REPLACE( REPLACE( REPLACE( REPLACE( REPLACE( REPLACE( REPLACE( REPLACE( REPLACE( u_grup, 'ü', 'u' ) , 'ç', 'c' ) , 'ö', 'o' ) , 'ı', 'i' ) , 'ş', 's' ) , 'ğ', 'g' ) , 'Ü', 'U' ) , 'Ç', 'C' ) , 'Ö', 'O' ) , 'Ş', 'S' ), ' ', '_' ) AS yeni FROM urunler – ZeQ Aug 26 '14 at 10:45
  • here you can see conversion using utf8:http://dev.mysql.com/doc/refman/5.0/en/charset-convert.html – Suchit kumar Aug 26 '14 at 10:50
  • end of search: Couldn't multiple convert to ş to s, ı to i, Ç to C in mysql query. – ZeQ Aug 27 '14 at 08:48