MyODBC - displaying EUC-JP characters
Hi, I have downloaded the latest version of MyODBC2.50.36NT and finished my setup. Now everything works fine if I display ASCII But if my table contains EUC-JP characters they dont get displayed properly. My SQL Server is running on RedHat Linux7.0 with Mysql3.23.33. I am using Access 2000 NT4.0. I got the following from MyODBC's readme file: If you are connecting to a server with a character set that isn't compiled into the MySQL client library (the defaults are: latin1 big5 czech euc_kr gb2312 gbk sjis tis620 ujis ) then you need to install the mysql character definitions from the charsets directory into the c:\mysql\share\charsets. how do I do this, where do I find the charsets? Does ODBC look for charsets under c:\mysql\share\charsets always? Is there a way I can tell ODBC to perform the encoding always? Am I missing anything? Please help. -Thiru -o0o "There is no finish line, you can always learn" "You have to keep pressure on yourself, you have to work on your weaknesses". Thiru S/W Engineer, Service Dvlpment Group Infoseek,Japan http://www.infoseek.co.jp - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Re : Question???
I havent done any FoxPro pgmming but if u could you get the error message returned from Mysql.. It sounds like user privilege problem... Cheers! Thiru On Thu, 22 Feb 2001 11:15:23 +0800 "edith" [EMAIL PROTECTED] wrote: - Dear Sir/Madam, - I'm a Visual FoxPro programmer. I want to use MySQL database for my programs. However, I cannot update MySQL database with my Visual FoxPro programs through ODBC (but I can view the record of table). My commands are as follow: - CREATE CONNECTION conn1 DATASOURCE "MySQL" USERID "users" DATABASE "tempdata" -STORE SQLSTRINGCONNECT('dsn=MySQL; uid=root; pwd=') TO xConnHandle //return of 'xConnHandle' is positive that means connection is successful// -=SQLSETPROP(xConnHandle,'Transactions',2) //this return is negative that means there is an error on connection level// - I don't know why I can view the table but I cannot update the table through ODBC. Would you help me to solve this problem? Thank you! - Regards, - Edith - -o0o "There is no finish line, you can always learn" "You have to keep pressure on yourself, you have to work on your weaknesses". Thiru S/W Engineer, Service Dvlpment Group Infoseek,Japan Voice - (81)-3-5453-2056 http://www.infoseek.co.jp - Click Here http://www.rakuten.co.jp - Click Here http://house.infoseek.co.jp - Click Here http://profile.infoseek.co.jp - Click Here http://chat.infoseek.co.jp - Click Here - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: JDBC question?
If U R using some IDE, then there shd be a place to add on Ur classpaths. If not, from the prompt For Windows java -classpath "c:\JDBCdriver;c:\JDBCdriver\driver.jar;." file.java For Unix java -classpath "/tmp/JDBCdriver:/tmp/JDBCdriver/driver.jar:." file.java note: when including jar or zip U have to include the fileName. Cheers! Thiru PS: U find extensiv dos on setting classpath. go to www.javasoft.com On Fri, 16 Feb 2001 20:29:27 +0800 Chen Ka Pong [EMAIL PROTECTED] wrote: - I cannot use the jdbc connection which the driver is download - from mysql web site. The error message prompted that - "invalid JDBC Driver", what can cause this error? - I predict my classpath is wrong, but I would like to know - how to set the classpath? - (at this status, I am not sure if my classpath is correct or not) - - Thanks! - - Pong - -o0o "There is no finish line, you can always learn" "You have to keep pressure on yourself, you have to work on your weaknesses". Thiru S/W Engineer, Service Dvlpment Group Infoseek,Japan Voice - (81)-3-5453-2056 http://www.infoseek.co.jp - Click Here http://www.rakuten.co.jp - Click Here http://house.infoseek.co.jp - Click Here http://profile.infoseek.co.jp - Click Here http://chat.infoseek.co.jp - Click Here - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: If, then, else . . .
Hi, U can do nested ifs in Mysql. I am not sure if there is a limit in the no of levels it can go upto. If U R going to do this for 1000's of records there may be a slight drop in performance. SELECT field1, if(field1="a",100,if(field1="b",200,"ERROR")) FROM table; will do perfect. Cheers! Thiru On Thu, 15 Feb 2001 16:32:25 -0700 John Halladay [EMAIL PROTECTED] wrote: - If I am querying a field that has either "a" or "b" as a value and I want a - second field's value to be dependant on the first field's value, how would I - right that? - - SELECT field1, IF(field1="a",100,IF(field1="b",200,"ERROR") FROM table; - - The IF,THEN,ELSE is the only thing I can think of, but that is the Excel, - Access side of my brain talking. Sorry for the basis question. Any help - would be much appreciated. - - Thanks. - - John H. - - - - Before posting, please check: -http://www.mysql.com/manual.php (the manual) -http://lists.mysql.com/ (the list archive) - - To request this thread, e-mail [EMAIL PROTECTED] - To unsubscribe, e-mail [EMAIL PROTECTED] - Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - - lB I --- T[rXJ peB@(a) eB |2402 --- - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Good tutorial sites
I have got the same confg and works perfect. WinNT Linux MySQL. Why dont U directly edit the user table of mysql DB. Let Host be '%' and give some username password. mysql insert into mysql.user values('%','username',password('passwd'),'Y','Y','Y'); For test purpose let all priv fields be 'Y'. Then try again it shud work. Cheers! Thiru On Thu, 15 Feb 2001 22:28:31 -0700 "Mike" [EMAIL PROTECTED] wrote: - Hi All - - Where are some good tutorial sites for beginners in the MySQL World. I read - the man pages as sugested but I am stuck on the GRANT HOST issues. I am - connecting my NT MyODBC to my LINUX's MySQL Server. - - I tried - mysql GRANT ... -ON *.* -TO myusername@"%100.100.100.1" -IDENTIFIED BY 'mypassword'; - - - but I get a syntax error. - - Good news is I figured out how to build tablesg - /'^'\ -( o o ) - ---oOOO--(_)--OOOo-- - - Mike Benzel - --- - To err is human, to really foul things up requires a computer. - .oooO - ( ) Oooo. - -\ (( )--- - \_)) / - (_/ - - - - - Before posting, please check: -http://www.mysql.com/manual.php (the manual) -http://lists.mysql.com/ (the list archive) - - To request this thread, e-mail [EMAIL PROTECTED] - To unsubscribe, e-mail [EMAIL PROTECTED] - Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - - lB I --- T[rXJ peB@(a) eB |2402 --- - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: installing mysql 3.23.33 rpm on RH7
I had the same problem just yesterday. - MySQL-DBI-perl-bin is needed by MySQL-bench-3.23.33-1 benchmark uses Perls DBI modules, so U have to install them before installing MySQL-bench. Unless U R going to perform benchmarking U need not install MySQL-bench modules. - mysql = 3.23.22 is needed by mysql-server-3.23.22-6 - mysql is needed by php-mysql-4.0.1pl2-9 - libmysqlclient.so.9 is needed by mysql-server-3.23.22-6 - libmysqlclient.so.9 is needed by php-mysql-4.0.1pl2-9 These are all again innterdependancy problems. 'cause RedHat7.0Server comes with MySQL3.23.22. Do the following: remove php-mysql-4.0.1pl2-9 remove mysql-server-3.23 and reisntall everything from the begining. also dont forget to install php-mysql-4.0.1pl2-9. Note: after installing rpm version on my Intel-RedHatLinux7.0 I had pblm setting administrator passwd, I tried mysql_db_install several times, but failed. So I got the source distribution and reinstalled from scratch. Anyone faced similar pblms??? Cheers, Thiru - - Pls advise on the correct installation procedure. - - Thanks. - - -o0o "There is no finish line, you can always learn" "You have to keep pressure on yourself, you have to work on your weaknesses". Thiru S/W Engineer, Service Dvlpment Group Infoseek,Japan Voice - (81)-3-5453-2056 http://www.infoseek.co.jp - Click Here http://www.rakuten.co.jp - Click Here http://house.infoseek.co.jp - Click Here http://profile.infoseek.co.jp - Click Here http://chat.infoseek.co.jp - Click Here - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Performance of Mysql updation ..
Hello, I am creating a script which works offline from the mainstream of our system and updates our databases. These scripts includes INSERTING, UPDATING and DELETING records. I am performing a updating operation using Python which takes really some time. Something like, update TABLE1 set col1=val1 where col2=something; col2 is indexed. val of something is set inside Python script. This statement is executed atleast 25 times. I beleive for the amt of work it is doing it is really fast, but by any means is there a way to step up the updation speed further?? like changing or adding some config options to my.cnf etc.. Please help. Thiru -o0o "There is no finish line, you can always learn" "You have to keep pressure on yourself, you have to work on your weaknesses". Thiru S/W Engineer, Service Dvlpment Group Infoseek,Japan Voice - (81)-3-5453-2056 http://www.infoseek.co.jp - Click Here http://www.rakuten.co.jp - Click Here http://house.infoseek.co.jp - Click Here http://profile.infoseek.co.jp - Click Here http://chat.infoseek.co.jp - Click Here - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php