Windows specific characters
Hello: I have some data in a spreadsheet that I need to load into a database. The data in the excel spreadsheet apparently contains windows specific characters. Whenever I import the data into my database, those special characters remain and since my database runs on an unix platform, I am getting all kinds of UTF-8 encoding problems in a separate application that is powered by this data. The tool that I am using to import the data is called Navicat. The folks there say that any data that contains double byte characters will be imported as such. So my question is if anybody knows of a tool that will get rid of those double byte characters or windows specific characters and replace them with standard ones. Thanks in advance - Do you Yahoo!? vote.yahoo.com - Register online to vote today!
Problem with imported data from mysqldump file
I am generating a backup of a database using mysqldump and using that dumped file to repopulate another database. The dump and import process work just fine, BUT I am having some problems in my application with some enconding issues. For example, one of the rows that mysqldump outputs is the following: INSERT INTO ap_step VALUES (9,'Determine if former employees UIDs are re-assigned. And if so, determine if a process exists for evaluating user rights.',3,3); As you can see the second column has some text with some single quotes. When I import the generated dumped file into the new database, I lose the single quotes in the text and this is causing some UTF-8 encoding problems in my application. select ap_step from ap_step where ap_step_id =9; ++ | ap_step | ++ | Determine if former employees UIDs are re-assigned. And if so, determine if a process exists for evaluating user rights. | ++ You will notice from the above query that the single quotes are gone. Whenever I remove this row from the table, my application works just fine. This is why I am almost certain that there is some encoding issues here. I need to be able to load my data back into the new database exactly as it is coming out of the old one. One thing that I do want to note is that the dumped file is generated in Windows XP and it is loaded into a new database in a Unix environment. If anyone could please point out some ideas I would appreciate it as this is basically a show stopper for us right now. Thanks in advance - Do you Yahoo!? Read only the mail you want - Yahoo! Mail SpamGuard.
Websphere and mysql
Hello: I have been trying to configure websphere 5 to use mysql. I have set up the datasource using the mysql driver and whenever I test the connection from the websphere admin console, I get the following: Test Connection failed for datasource Securance Datasource on server server1 at node linux with the following exception: java.lang.Exception: DSRA8101E: DataSource class cannot be used as one-phase: ClassCastException: com.mysql.jdbc.Driver. View JVM logs for further details. null If this was the wrong list to post, please forgive me and let me know which is the appropriate list to post. Thanks in advance - Do you Yahoo!? Yahoo! SiteBuilder - Free web site building tool. Try it!
Problem with websphere configuration
Hello: I have been trying to configure websphere 5 to use mysql. I have set up the datasource using the mysql driver and whenever I test the connection from the websphere admin console, I get the following: Test Connection failed for datasource Securance Datasource on server server1 at node linux with the following exception: java.lang.Exception: DSRA8101E: DataSource class cannot be used as one-phase: ClassCastException: com.mysql.jdbc.Driver. View JVM logs for further details. null If this was the wrong list to post, please forgive me and let me know which is the appropriate list to post. Thanks in advance __ Do you Yahoo!? Yahoo! SiteBuilder - Free web site building tool. Try it! http://webhosting.yahoo.com/ps/sb/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
