开发者

Is it possible to store commas instead of points for decimal fields in a PostgreSQL database?

Is it possible to store commas instead of points 开发者_如何转开发for decimal fields in a PostgreSQL database?


That has nothing to do with PostgreSQL. PostgreSQL does not store commas or points for decimal fields. It uses an internal number representation for numbers (int, floats, numeric).

If you need to format numeric information with PostgreSQL, you can use to_char function or use your client side programming language to format numbers.


Why? No programming language will accept decimals using comma's as a seperator. Presentation should be done in the presentation layer of your application, not in the storage layer.

http://www.php.net/manual/en/language.types.float.php

0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜