Encerrado

Postgresql Database Localization

ANTS is a client/server VB application that was developed in the United States. In the past three months this application has been released for use in other countries:

Europe: Germany, Sweden, Spain, France

Australia:

Asia Pacific: South Korea

Due to date, time, numerical (decimal), currency, language/format differences from country to country communication between the client application (MS Access) and database (PostgreSQL) seems to cause errors. For example, in the American system a decimal number is represented as: 1,[url removed, login to view] however in the European system its represented as [url removed, login to view],56 . As a result when this value is inserted into the database it comes back with an error stating that the format is incorrect. Currently, the database encoding is SQL_ASCII. The current method that’s used today to get around this issue is to trigger a VB module that changes the users system settings to United States when they are using this application. However, this causes problems when they want to use other software while ANTS is open.

The recommended solution would be to have the database accept/understand the incoming data and store the data in an american format.

Links for reference:

[url removed, login to view]

[url removed, login to view]

Habilidades: Visual Basic

Ver mais: postgresql localization data, database localization, is incorrect, asia pacific language solution, access database module, client database software, american software, united states, south australia, recommended, pacific, numerical solution, localization, korea, database australia, asia pacific, accept language, client server encoding, application store visual basic, differences, settings visual basic language, currency html, database example, visual basic currency, access database problems

Acerca do Empregador:
( 7 comentários ) Rochester Hills, United States

ID do Projeto: #143904

1 freelancer está ofertando em média $300 para este trabalho

SankarKoki

Hi, I am 7 years experience progarammer from Singapore. I have good knowledge in Localization based Control Panel settings with VB. I am bidding with confident. Please let me know if you wish me to do ur project. Tha Mais

$300 USD in 7 dias
(0 Comentários)
0.0