英镑符号（£）未插入数据库 [英] Pound sign(£) not getting inserted in database

问题描述

我有1个表名代理（broker_id，名称，bname，地点，日期，年份） - 其中broker_id是主键



我有1个表名项目（broker_id是外键，名称，bname，地点，日期，年份，lot_no，lname，描述，curr，amt）



现在curr是货币列，我用了1个组合框，里面有3个货币符号

$

฿

£



ี选择美元和泰国标志后，该符号将被插入我的数据库，但是当我选择英镑符号时，

，？（问号）标志将被插入数据库中。



任何人都可以帮助我，为什么会这样呢？



提前致谢

解决方案

฿

£



ี选择美元和泰国巴特标志，该符号插入我的数据库，但

，当我选择英镑符号，？（问号）标志是我插在数据库中。



任何人都可以帮助我，为什么会这样呢？



谢谢提前

这里有两种可能：

1）它被正确插入，但之后显示不正确

2 ）没有正确插入。



第一个很难远程修复：你需要看看你是如何显示它并找出实际显示的内容 - 如果可以的话，尝试将它放在工作的£符号旁边，如果可以的话，看看调试器的区别是什么。



第二个可能是simle：检查数据库列上的Collat​​ion属性：如果它不是Latin1_General_CI_AS，那么尝试将其更改为那个，看看是否有所作为 - 但仔细检查，你可能会失去Bhat标志......：笑：

i have 1 table name agent(broker_id,name,bname,place,date,year)-here broker_id is primary key

I have 1 table name item(broker_id is the foreign key,name,bname,place,date,year,lot_no,lname,description,curr,amt)

now curr is the currency column and i have used 1 combo box where 3 currency symbols are there
$
฿
£

ีupon selection of dollar and thai bhat sign, that symbol is getting inserted in my database but
when i select pound sign, ?(question mark) sign is getting inserted in database.

Can anyone please help me,why is it happening so?

Thanks in advance

解决方案

฿
£

ีupon selection of dollar and thai bhat sign, that symbol is getting inserted in my database but
when i select pound sign, ?(question mark) sign is getting inserted in database.

Can anyone please help me,why is it happening so?

Thanks in advance

There are two possibilities here:
1) It is getting inserted correctly, but it is being displayed incorrectly afterwards
2) It is not being inserted correctly.

The first is hard to fix remotely: You need to look at how you are displaying it and find out what is actually being displayed - try to put it right next to a working "£" sign if you can and see what the difference is in the debugger if you can.

The second may be simle: Check your Collation property on the DB Column: If it isn't "Latin1_General_CI_AS" then try changing it to that and see if that makes a difference - but check carefully, you may lose the Bhat sign...:laugh:

这篇关于英镑符号（£）未插入数据库的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！