Member Avatar for Dragutin

Hello,I'm having problem with SQL INSERT statement
In Europe we use comma instead dot for decimal number.
But when I try to insert it with SQL statement I get this error:
"Number of query values and destination fields are not the same."
Can anyone help me with this?
Thanks

  • 2 Contributors
  • 1 Reply
  • 20 Views
  • 6 Hours Discussion Span
  • Latest Post Latest Post by Momerath
Member Avatar for Momerath

When you install your database it usually asks what region encoding to use, or uses what .NET refers to as InvariantCulture (which is very much like USA settings).

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.