| |
| |
| |
|
Page: 1 2
Comments:
<0> hey. ive download the zip for linux (mysql 4.1) , how do i install & configure it?
<1> hey. ive download the zip for linux (mysql 4.1) , how do i install & configure it?
<2> hello, a question pls: i have mysql 4.1.10 and wanna insert data with special spanish characters in spanish via HTML-PHP forms,
<2> but the data inserted is rare sings like this: "&{&??" - i have read that the solution could be charset and i have done it in mysql, but the problem continues... pls is there anyone that could help?
<3> find collation and character sets that are supported for spanish
<2> s3892, i did that in a table
<3> and then use the correct syntaxt to set your database or tables or colums to use that collation and character set
<3> well maybe its the web server
<3> not mysql
<2> yes
<2> all this i am doing in localhost
<2> for testing
<2> muss i modify My.ini or httpd.conf or Php.ini?
<3> did you set AddDefaultCharset for your apache conf
<3> just play with ur browsers encoding settings
<3> if it displays right results
<3> when u pick the encoding standarts for your browser
<2> thanks
<3> then it s not from mysql
<2> i believe so
<2> but there are a lot of AddDefaultCharset...
<3> and next time try #apache ;)
<2> haha
<3> pick the one for spanish
<3> dunno whats the charset for spanish
<3> should be same the one u use with mysql
<2> excuse, i am a newbie... how do i pick?
<3> srry its not u its my lazy english
<3> u using ie?
<2> yes
<3> view->encoding->(spanish or anything that would make it display as you want it as)
<2> it says UNICODE UTF-8
<2> as everybody recommends
<3> change it to spanish and see if it fixes your chars
<3> also hopefully you saved your localfiles as utf-8
<3> not .txt
<2> good idea, but ie shows normally spanish characters, the problem is when you want to insert data with special characters from a HTML form to a MySQL database
<3> i mean not ansi .txt
<2> anyway, a lot of thanks
<3> you mean when you display them?
<2> yes
<3> does it show properly when you change encoding type to spanish?
<2> no
<2> i have changed the charset to lati1_spanish
<2> to an specific table
<2> when i insert data via command line in mysql-dos, all is good,
<2> but when i insert it from a form, html and then pho, the characters have changed
<2> changed
<2> pho=php
<2> what can i do?
<2> i have read a lot
<2> but nothing works
<3> well if it was with mysql 5.0x i could say it could be a bug
<2> yeah...
<3> but with 4.1 things work fine with me i am using lotz of special chars as well
<2> i see this problem is very commom in spanish people
<2> what is ur language?
<3> turkish
<2> great, i have read about turkish chars
<3> lol
<2> and i think the problem is similar
<2> what have u done ti solve ut?
<3> 1st i save all my files as utf-8
<3> in local
<2> ok, html and php
<2> right?
<3> yea
<3> i got the directive in http conf AddDefaultCharset latin5
<2> pls a question...
<2> how do you choose latin5 from apache conf?
<3> what do you mean?
<2> say, there are a lot of AddDefaultCharset in a list in httpd.conf
<3> you mean give them priorities?
<2> yes
<3> well i dont i just pick latin5 as default charset
<2> yes friend, but how?
<3> or ur html headers should have meta tags
<3> i just paste AddDefaultCharset latin5
<4> did you issue a SET NAMES 'utf8';
<3> in http.conf
<4> or whichever character set?
<4> you need to do so to change the protocol charset
<4> SHOW VARIABLES LIKE '%char%';
<3> K_F knows better about this issues
<3> you should listen to him
<2> thanks
<2> i did
<2> i am re-reading...
<4> http://dev.mysql.com/doc/refman/5.0/en/charset-connection.html
<2> i have wrote:
<2> shell> ALTER TABLE table_name CHARACTER SET latin1 COLLATE latin1_spanish_ci;
<2> that says in DEv.Mysql Manual
<2> but maybe in should be done in all the database
<2> i will do it now
<4> try to use utf8
<4> tend to be easier
<2> yes, i guess so
<2> but please, what would be the command line?
<2> -i am a newbie
<2> in Dev.Mysql manual i dont find it
<4> to do what?
<4> http://dev.mysql.com/doc/refman/5.0/en/charset.html
<2> thanks
<4> ALTER TABLE tbl_name CONVERT TO CHARACTER SET charset_name [COLLATE collation_name];
<4> might be handy as well
<2> thanks, i guess it should be:
<2> ALTER TABLE tbl_name CONVERT TO CHARACTER SET utf8 COLLATE utf8_spanish_ci;
<2> am i right, mr K?
<2> or muss i write: ALTER TABLE tbl_name CONVERT TO CHARACTER SET latin1 COLLATE utf8_spanish_ci; ?
<4> no, first one
<5> Anyone aware of the issue in mysql 4.1 where a varchar starting with a number, finds the product number?
<2> perfect Mr K, i will do it right now
<5> ie if I search for the following, I get the row with product code of '6', when I'm not trying to find '6', I'm trying to find '6tk'
<5> SELECT * FROM products WHERE product_number = '6TK' AND product_client = '11'
<5> Any ideas?
<6> goodnight poeple
Return to
#mysql
or
Go to some related
logs:
turkhs mean
#linuxhelp
cannot lock password filelinux
#linuxhelp
#php
#chatzone
php 5.1.2-5 src rpm
#teens
php in htaccess
#c++
|
|