[SOLVED] mssql set language

#1
[eluser]fdog[/eluser]
I need to change the language of my app using mssql.

For example:
Code:
Set language Spanish;
select datename(MM,getdate());
That will output "Septiembre".

The problem is that CodeIgniter doesn't seem to get the 'Set language Spanish' part.
I tried using
Code:
$this->db->simple_query('Set language Spanish')
before doing my regular queries, but it didn't work.
Does anyone knows how to get that working?

Thank you.

#2
[eluser]fdog[/eluser]
Never mind. It was my mistake. I just forgot to convert the date from the database.


Digg   Delicious   Reddit   Facebook   Twitter   StumbleUpon  


  Theme © 2014 iAndrew  
Powered By MyBB, © 2002-2020 MyBB Group.