drwo2014 2013-08-26 08:49
浏览 23

使用拉丁字符的HTML和MySQL问题

I am trying to create my first web page using Yii, PHP and MySQL. I have some problems using latin characters. When I write these characters I can't show them correctly, for example:

ID: 1   
Username: José MiguelEDITADO
Password: contraseñaJosemi 

Besides, I have the same problem when I try to store this characters in the DB. I mean, when I complete a form field and click on submit, if one of theses fields have latin characters, the DB only store the text of the field up to the latin character. For example:

If write "María" in the form field the DB store "Mar" inthe corresponding register.

I know that I have a problem with the charset but I don't know why. In the db array of my main.php I have:

    'db'=>array(
                     ...
        'charset' => 'utf8',
    ),

Besides in the registers of my DB I use "varchar(100) utf8_general_ci". In the document main.php I also have:

return array(
'basePath'=>dirname(__FILE__).DIRECTORY_SEPARATOR.'..',
'name'=>'Prueba',
'language'=>'es',
'sourceLanguage'=>'en',
'charset'=>'utf-8',

I am using notepad++ to edit and to create the php documents, and the codification of these documents is UTF-8 sin BOM.

Please, I need your help, I don't know that is my error. Somebody could help me?

Thank you very much.

  • 写回答

0条回答 默认 最新

    报告相同问题?

    悬赏问题

    • ¥15 python的qt5界面
    • ¥15 无线电能传输系统MATLAB仿真问题
    • ¥50 如何用脚本实现输入法的热键设置
    • ¥20 我想使用一些网络协议或者部分协议也行,主要想实现类似于traceroute的一定步长内的路由拓扑功能
    • ¥30 深度学习,前后端连接
    • ¥15 孟德尔随机化结果不一致
    • ¥15 apm2.8飞控罗盘bad health,加速度计校准失败
    • ¥15 求解O-S方程的特征值问题给出边界层布拉休斯平行流的中性曲线
    • ¥15 谁有desed数据集呀
    • ¥20 手写数字识别运行c仿真时,程序报错错误代码sim211-100