Subject RE: [firebird-support] in MySql i use PASSWORD. what can i use in FireBird ?
Author Alan McDonald
> in Mysql i can write something like this:
> UPDATE mysql.user SET Password=PASSWORD('newpass')
>
> in Firebird i get this:
> ErrMsg :
> Dynamic SQL Error SQL error code = -104 Token unknown - line 1, char
> 54 PASSWORD ErrCode : -104
>
> when i write this:
> SELECT * FROM utilizatori WHERE id = "x" AND pass = PASSWORD("x")
>
> if someone knows how to solve this please answer
> Thank You

This isn't MySQL. PASSWORD is not a standard SQL function.
There is an UDF to encrypt passwords f_ibpassword() if you install the
freeudf library.

Alan