SQL Server 汉字和耶鲁罗马化的数据类型
我正在制作一个学习粤语的游戏。核心组件是包含以下列的数据库表：
汉字 |耶鲁罗马化| ？
我应该为第一列和第二列选择什么 SQL Server 数据类型
我还不知道我的源数据来自哪里。所以我还不能告诉你它将使用什么编码。我最好的猜测是 UTF-8。
*编辑 - 我现在知道我的源数据来自哪里。有人会手动将其输入到 Excel 电子表格中，然后我将导入该电子表格。这提出了两个相关的问题。首先，Excel 电子表格应保存为什么格式才能保留耶鲁罗马化的重音符号？其次，任何支持必要重音符号的字体都可以接受吗？或者只有某些字体与必要的字符编码兼容？
I'm building a game for learning Cantonese. A core component is a database table with the following columns:
Chinese Character(s) | Yale Romanization | English Equivalent
What SQL Server data type should I choose for the first and second columns?
I do not yet know where my source data will come from. So I can't yet tell you what encoding it will use. My best guess is UTF-8.
*EDIT - I now know where my source data will come from. Someone will manually enter it into an Excel spreadsheet that I will then import. This raises two related questions. First, what format should the Excel spreadhsheet be saved in to preserve accent marks that are part of Yale romanization? Second, is any font that supports the requisite accent marks acceptable? Or are only certain fonts compatible with the necessary character encoding?
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（1）
nvarchar将是 unicode、可变长度字符串的选择。您还可以为表中的每个字段设置排序规则。至于Excel，我会测试一下。我的猜测是 Excel 会保留排序规则，但最好的方法是对其进行测试。
nvarcharwould be the choice for unicode, variable length strings. And you can set collation for each field in the table as well.As for Excel, I would test it out. My guess would be that Excel would preserve collation, but the best way would be to test it out.