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,508
  • 6
  • 37
  • 59
ZeQ
  • 51
  • 3
  • 9

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,809
  • 3
  • 22
  • 44
  • 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