Forums
New posts
Articles
Product Reviews
Policies
FAQ
Log in
Register
What's new
Search
Search
Search titles only
By:
New posts
Menu
Log in
Register
Install the app
Install
Forums
General Discussions
Switcher Hangout (Windows to Mac)
Doing SQL on the Mac
JavaScript is disabled. For a better experience, please enable JavaScript in your browser before proceeding.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an
alternative browser
.
Reply to thread
Message
<blockquote data-quote="Kokopelli" data-source="post: 89884"><p>Hmm, learn something new every day. I did not know Oracle had a Mac port.</p><p></p><p>For MS SQL Server the school did not provide SQL server or a lab with a server available? Yes, if you are connecting to local it is assuming the server is running on the same machine. You can connect to remote machines as well without a problem but that is not pertinent to the discussion at hand. I would strongly suggest that you see if your school has MS SQL Server for sale or available for educational use. MySQL and SQL server have different foibles and what works on one may not work on one may not work on the other.</p><p></p><p>As an example MySQL has BLOB support and a default maximum VARCHAR length of 255 as I recall. MS SQL Server on the other hand does not have formal BLOB support but instead uses VARBINARY and IMAGE support as I recall. The default maximum VARCHAR is also something like 8000. Further when you get into unicode support it varies by platform as well as an example.</p><p></p><p>So to rely on MySQL for an assignment where they are using MS SQL Server as the standard would not be wise.</p></blockquote><p></p>
[QUOTE="Kokopelli, post: 89884"] Hmm, learn something new every day. I did not know Oracle had a Mac port. For MS SQL Server the school did not provide SQL server or a lab with a server available? Yes, if you are connecting to local it is assuming the server is running on the same machine. You can connect to remote machines as well without a problem but that is not pertinent to the discussion at hand. I would strongly suggest that you see if your school has MS SQL Server for sale or available for educational use. MySQL and SQL server have different foibles and what works on one may not work on one may not work on the other. As an example MySQL has BLOB support and a default maximum VARCHAR length of 255 as I recall. MS SQL Server on the other hand does not have formal BLOB support but instead uses VARBINARY and IMAGE support as I recall. The default maximum VARCHAR is also something like 8000. Further when you get into unicode support it varies by platform as well as an example. So to rely on MySQL for an assignment where they are using MS SQL Server as the standard would not be wise. [/QUOTE]
Verification
Post reply
Forums
General Discussions
Switcher Hangout (Windows to Mac)
Doing SQL on the Mac
Top