回复： MySQL 4.1.13 and utf-8 language encoding
firstly,I don't use utf8,then maybe this will help you,first dump out your in sql form,then find a mysql 4.1 with phpmyadmin 2.5* computer,or make one,then deploy your sql in the latin mode,then dump out it again,redeploy it on your web host,i think it will do,and no matter how you modify phpmyadmin 2.6 ,no matter utf8 or latin or gb,you will find ? in phpmyadmin all the time ,i don't know how to fix it,and it will be ok on your page 立 周 [EMAIL PROTECTED] 写道： --- 维斯 苏 写道: just use phpmyadmin 2.5* because the 2.6* default use utf8,what you need to do is dump out your old mysql in sql form, use phpmyadmin 2.5* to redeploy it on 4.1*. That is it. I don't have control over phpmyadmin version because it is on a shared hosting plan. Can i manually modify the SQL and explisively set collation attributes to unicode_general_ci? because the collation attribute does exist on MySQL 4.0, and 4.1.13 server is default to latin1_swedish_ci. Will this work out? http://www.cnads.org/ thanks. __ 赶快注册雅虎超大容量免费邮箱? http://cn.mail.yahoo.com __ 赶快注册雅虎超大容量免费邮箱? http://cn.mail.yahoo.com
回复： MySQL 4.1.13 and utf-8 language encoding
just use phpmyadmin 2.5* because the 2.6* default use utf8,what you need to do is dump out your old mysql in sql form, use phpmyadmin 2.5* to redeploy it on 4.1*. That is it. 立 周 [EMAIL PROTECTED] 写道： Hello list: I have a php website which uses utf-8 encoding. But recently the shared hosting company has upgraded mySQL to 4.1.13 and now all varchars are shown incorrectly ( all collation attribute are set as latin_swidish_ci now ).. the phpMyAdmin verson is 2.6.4-pl2. my site is at http://www.cnads.org/. Can anyone tell me how to fix this? Thanks Li __ 赶快注册雅虎超大容量免费邮箱? http://cn.mail.yahoo.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] __ 赶快注册雅虎超大容量免费邮箱? http://cn.mail.yahoo.com
回复： Charset issue
no,you do not need to modify anything,it just because utf8 which phpmyadmin2.6 default setting conflict with mysql's latin1,so just copy a set of phpmyadmin 2.5.5,and install the mysql 4.1 as default,and every will be ok,that's all. 王静 [EMAIL PROTECTED] 写道：hi all. Here is the suituation. i've installed mysql 4.1.12 on WinXP plantform, it seems not to support Chinese by its default configuration, say, Chinese can't be displayer propely. as far as i know, what i need to do is modify the charset(server, connection, client...)concerned, but i'm not so sure and is there anything else i should do and howto? 3x. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] - 雅虎免费G邮箱－中国第一绝无垃圾邮件骚扰超大邮箱 雅虎助手－搜索、杀毒、防骚扰
re:how to arrange my table in another direction
thank you but after i read it, I try the second example Pivot table using a JOIN Problem: You have table user_class(user_id int, class_id char(20), class_value char(20)) with these rows: user_id class_id class_value 1firstname Rogier 1lastname Marat 2firstname Jean 2lastname Smith and you wish create this resultset: user_id firstname lastname 1Rogier Marat 2Jean Smith This query accomplishes the required pivot table via an INNER JOIN: SELECT t1.user_ID, class_value AS firstname, t2.lastname FROM user_class AS t1 INNER JOIN ( SELECT user_ID, class_value AS lastname FROM user_class WHERE class_id='lastname' ) AS t2 ON t1.user_ID=t2.user_ID AND t1.class_id='firstname' but,the query cannot run on my mysql 4.0.23 it returns: SQL 查询 : SELECT t1.user_ID, class_value AS firstname, t2.lastname FROM user_class AS t1 INNER JOIN ( SELECT user_ID, class_value AS lastname FROM user_class WHERE class_id = 'lastname' ) AS t2 ON t1.user_ID = t2.user_ID AND t1.class_id = 'firstname' LIMIT 0 , 30 MySQL 返回: #1064 - You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT user_ID, class_value AS lastname FROM user_class WHERE c How can i fix it? and thank you for your help. - DO YOU YAHOO!? 雅虎免费G邮箱－中国第一绝无垃圾邮件骚扰超大邮箱
Re: how to arrange my table in another direction
Hello. Please, answer next time to the list as well. In my opinion, it is easier to prepare the create statement on the client side than on the server. And does this table have any sense, considering the relational model? Sorry,I think you misunderstand my purpose,table2 is my query result,in fact my trouble is id customer goods1 price1 goods2 price2 goods3 price3 1 miketv 100 car 100 bike 20 2 jin pc 200psp 200 x360 299 i can't change the table,so I want a query,after the query,the value in goods1 goods2 become the column name,then their value are price1 and price2,i try many methods,but i can't get the result - DO YOU YAHOO!? 雅虎免费G邮箱－No.1的防毒防垃圾超大邮箱
how to arrange my table in another direction
My table is: type price car1000 bike 100 I want the result: car bike 1000100 I don't know how to get that result. - DO YOU YAHOO!? 雅虎邮箱超强增值服务－2G超大空间、pop3收信、无限量邮件提醒
