[SOLVED] mssql set language - Printable Version

[SOLVED] mssql set language - Printable Version

+- CodeIgniter Forums (https://forum.codeigniter.com)
+-- Forum: Archived Discussions (https://forum.codeigniter.com/forumdisplay.php?fid=20)
+--- Forum: Archived General Discussion (https://forum.codeigniter.com/forumdisplay.php?fid=21)
+--- Thread: [SOLVED] mssql set language (/showthread.php?tid=22260)

[SOLVED] mssql set language - El Forum - 09-02-2009

[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.

[SOLVED] mssql set language - El Forum - 09-02-2009

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