Please be aware that the content in SAP SQL Anywhere Forum will be migrated to the SAP Community in August and this forum will be retired.

Hi, I have a database that was done unload / reload and the individual who made the option selected case sensitive. Now how do I change case sensitive password for off? Set casesentitivepassword = off ??

asked 22 May '13, 09:24

Walmir%20Taques's gravatar image

Walmir Taques
accept rate: 12%

edited 22 May '13, 21:00

Mark%20Culp's gravatar image

Mark Culp

Except in very, very old versions of SQLAnywhere, passwords are always case sensitive:

permanent link

answered 22 May '13, 09:29

John%20Smirnios's gravatar image

John Smirnios
accept rate: 37%


Where "very, very old" means "v9 or older", IIRC...

Note: When unloading such a very, very old and case-insensitive database into a new version, existing passwords will remain case-insensitive even in the new version (until you modify them, of course) - cf. the help.

(22 May '13, 09:55) Volker Barth
Replies hidden

Thank you. It was older than I cared to research because the oldest version on dcx was case-sensitive. :)

(22 May '13, 09:58) John Smirnios

Well, I regularly have to cope with even much older versions than those very, very old ones...:)

(22 May '13, 10:00) Volker Barth

John is correct except that passwords reloaded from an old database with case-insensitive passwords are still case-insensitive. Once those passwords are changed, they will become case-sensitive.

(22 May '13, 18:09) Graeme Perrow
Replies hidden

It that not what I had already mentioned in my comment? Or have I missed a subtle difference?

(23 May '13, 03:19) Volker Barth

Yes, that's exactly what you had in your comment. I just wanted to... um... I thought I should... It was really... OK, I got nothing. Total fail on my part.

(23 May '13, 08:51) Graeme Perrow

Thanks for the clarification - and w.r.t. feeling "very, very old" - been there, too:)

(23 May '13, 09:52) Volker Barth
showing 2 of 7 show all flat view
Your answer
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here



Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text]( "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Question tags:


question asked: 22 May '13, 09:24

question was seen: 3,074 times

last updated: 24 May '13, 16:12