Results 1 to 3 of 3
  1. #1
    Join Date
    Dec 2002
    Location
    Préverenges, Switzerland
    Posts
    3,740

    Unanswered: Korean date format errors

    can anyone offer some info?

    i have something like
    strSQL = "UPDATE myTable SET myDate = #" & someDate & "# WHERE myID = 99;"

    this works in every version of everything except Korean-XP which returns a 3075 showing some Korean characters in the middle of an otherwise correctly formatted yyyy-mm-dd XX hh:mm:ss
    XX are the unexpected characters as in attached .GIF

    what are these chars?
    how to get rid of them?

    izy
    Last edited by izyrider; 02-05-08 at 14:24.
    currently using SS 2008R2

  2. #2
    Join Date
    Nov 2004
    Location
    Norway
    Posts
    441
    Did you format the date?

    ...myDate = #" & format$(someDate, "yyyy\-mm\-dd\ hh\:nn\:ss") & "# WHERE...

    as in http://allenbrowne.com/ser-36.html or http://www.mvps.org/access/datetime/date0005.htm
    Roy-Vidar

  3. #3
    Join Date
    Dec 2002
    Location
    Préverenges, Switzerland
    Posts
    3,740
    hi Roy,

    thanks!

    my first thoughts were that you had to be joking - i'm not some sort of simple bumpkin and i don't make those sort of crass errors - of course all my SQL explicitly forces dates into USA or ISO (i prefer) format strings...

    ...but i found two cases dealing with datetimes (not strings) in this application where Korean-XP perverted the format. forcing in the ISO string format fixed the problem.

    this app has worked worldwide (including under Korean-2K and all sorts of other local language Wins 95 / 2K / XP) for a few years. a user upgrades to Korean-XP and it dropped dead!

    here's an interesting one for the debug window:

    ? isdate(format$(now(), "Long Date"))
    ...in Korean-XP it returns False !

    stupid thing cant even understand it's own date formats !

    izy


    oh yes - those mystery chars turn out to be equivalent to 'PM'
    Last edited by izyrider; 08-22-06 at 13:19.
    currently using SS 2008R2

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •