![]() |
|
Welcome to the Computer Webmaster Gaming Console Graphics Forum forums. You are currently viewing our boards as a guest which gives you limited access to view most discussions and access our other features. By joining our free community you will have access to post topics, communicate privately with other members (PM), respond to polls, upload content and access many other special features. Registration is fast, simple and absolutely free so please, join our community today! If you have any problems with the registration process or your account login, please contact contact us. |
| |||||||
| Database Database problems or need to ask a question? maybe something to do with sql injections or a database software question. Database topics cover MySQL, PostgreSQL, Oracle, SQL Server or anything else related to databases. |
![]() |
| | LinkBack | Thread Tools | Display Modes |
| | #1 | ||
| Hi! I've created a mysql database (v4.1.9) with the default charset utf8 and I'm doing some web pages with PHP (v4.3.2) also using UTF-8. Database insertion works great, even when using strange characters but search doesn't work always, for instance: - a search for "não" or "NãO" gives 3 results - "nao", "nÃo" and "NÃO" gives no results Seems like the search is not case-insensitive (or accent-insensitive for that matter) when using accented characters (or any greater than 127). I've double checked the mysql table settings, did a "ALTER TABLE mytablename DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci" just to make sure and nothing works. Anyone got ideas on how to solve this problem? Thanks in advance! | |||
|
| Featured Websites | ||||
|
![]() |
| Tags: mysql, php, utf8 |
| Currently Active Users Viewing This Thread: 1 (0 members and 1 guests) | |
| Thread Tools | |
| Display Modes | |
| |
Similar Threads | ||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| can't logon to db with mysql client: mysql 5 passwords | rog | Database | 2 | 07-01-2007 9:31 PM |
| ERROR 2002: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) | Cteodor | Database | 0 | 07-01-2007 6:43 PM |
| [Periodic Charter Post] comp.databases.mysql - MySQL RDBMS technical discussions. | Gary L. Burnore | Database | 0 | 07-01-2007 6:27 PM |
| MySQL Query Cache Not Working: MySQL 5 / Windows XP | Good Man | Database | 0 | 07-01-2007 6:25 PM |
| MySQL Query Cache Not Working: MySQL 5 / Windows XP | Good Man | Database | 0 | 05-31-2007 8:46 PM |
| Featured Websites | ||||
|