RE: BLOB data gets encoded as utf8!

via ODBC from C++ / MFC. Do you think that could be the issue? If so, do you have a suggestion on how to do it better? Thank you again for your help! Sincerely, Andreas Iwanowski -Original Message- From: Janusz Paśkiewicz [mailto:ad...@multipasko.pl] Sent: Wednesday, February 09

BLOB data gets encoded as utf8! (Anyone?)

Has no one encountered this before? There has got to be a solution, and I still haven't found it... So if you have any input please let me know! -Original Message- From: Andreas Iwanowski [mailto:namez...@afim.info] Sent: Tuesday, August 24, 2010 2:48 PM To: mysql@lists.mysql.com

BLOB data gets encoded as utf8!

Hello everyone! I am using an MFC unicode project that uses ODBC to access a MySQL 5.1.50 database via the MySQL ODBC 5.1.6 driver. One of the tables contains two LONGBLOB columns, and the table default charset is utf-8 (since the application is unicode). However, when inserting into the

BLOB data gets encoded as utf8! (First post incomplete)

Hello everyone! I am using an MFC unicode project that uses ODBC to access a MySQL 5.1.50 database via the MySQL ODBC 5.1.6 driver. character_set_connection is set to utf8 (Which I believe is the default for the driver) One of the tables contains two LONGBLOB columns, and the table default

JOIN to replace column?

Hello MySQL community, I have a table that contains a foreign key, e.g. ID - Local unique key UserID - Foreign key Data Is it possible to do a JOIN on the Users table to replace UserID with the name of the user, as in the Name column of the Users table? I've tried several JOINS, but I JOIN the

RE: Order By and Ignore Punctuation

I would suggest you order by something that includes a fulltext index on the specific column. Maybe check out the documentation on the MATCH()AGAINST() systax as well as fulltext searches in general. For example: SELECT Col1, Col2, Score AS MATCH(TextCol) AGAINST () WHERE ... ORDER BY Score;

RE: View with Subselect for User ID

Hello Christian, Thank you very much for this reply. It was very helpful, and the user matching part works as it should. Is there any way to JOIN on two tables, so I can match the Users.GroupID field against a JOIN on Groups.ID? Also, I tried adding a WHERE clause after the join to compare

RE: View with Subselect for User ID

))); --- -Original Message- From: Martijn Tonies [mailto:[EMAIL PROTECTED] Sent: Tuesday, April 24, 2007 12:09 PM To: Andreas Iwanowski Cc: mysql@lists.mysql.com Subject: Re: View with Subselect for User ID Hello Andreas, I tried the following statement: CREATE

View with Subselect for User ID

Hello MySQL experts, I am trying to create a view whose access is based on a User ID that need to be looked up in a different table. Here is an example of what I'm trying to do: CREATE OR REPLACE ALGORITHM=UNDEFINED [EMAIL PROTECTED] SQL SECURITY DEFINER VIEW `shared_v` AS select `Shared`.`ID`

RE: Trying to open a big sql script

If you are under windows, you should try Textpad (http://www.textpad.com/) In any case, a hex editor will do what you're looking for. Hope to help, Andy -Original Message- From: molemenacer [mailto:[EMAIL PROTECTED] Sent: Thursday, April 19, 2007 6:44 AM To: mysql@lists.mysql.com

Fulltext search dilemma (IN BOOLEAN MODE)

Hello MySQL experts, I'm trying to do a full text search on an indexed Keywords column that contains quotation marks, and it's giving me a headache. Suppose there are records in the database containing the folling keywords: 1. Miami Beach City 2. Key West Florida 3. Key West Beach Florida Now I

RE: Fulltext search dilemma (IN BOOLEAN MODE)

01, 2007 1:52 PM To: Andreas Iwanowski; mysql@lists.mysql.com Subject: RE: Fulltext search dilemma (IN BOOLEAN MODE) Unless you changed the minimum word length, Key would be ignored because it is too short. I would think the quotation marks at the start or end of the words would be ignored

RE: Fulltext search dilemma (IN BOOLEAN MODE) [RESOLVED]

, the server was always shut down properly. -Andy -Original Message- From: Jerry Schwartz [mailto:[EMAIL PROTECTED] Sent: Thursday, February 01, 2007 4:10 PM To: Andreas Iwanowski Cc: mysql@lists.mysql.com Subject: RE: Fulltext search dilemma (IN BOOLEAN MODE) Sorry, I have no idea what

Cant't connect through /var/lib/mysql/mysql.sock

Hi My PHP Websites all terminate with that error: Warning: MySQL Connection Failed: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111) in lib.inc.php on line 255 I already set User rights, but what can i do against that. On my CGI modules that error occurs: