Update DBI.pm - really now

[LaXKo]

• Addressed an issue with syb_db_use() truncating database names after 32chars in ct_command by bypassing the DSN "database" parameter entirely.
• Instead, added an explicit "USE " statement post-connection, ensuring the correct database context without triggering truncation behavior.

This update improves connection stability and prevents issues with database names exceeding length limits, as encountered in some Sybase or FreeTDS configurations.

[codeautopilot[bot]]

PR summary

This Pull Request addresses an issue in the DBI.pm file where the syb_db_use() function was truncating database names longer than 32 characters when using the ct_command method. The solution implemented bypasses the DSN "database" parameter and instead uses an explicit "USE " SQL statement after establishing a connection. This change ensures that the correct database context is set without encountering truncation issues, thereby improving connection stability, especially in environments using Sybase or FreeTDS configurations with long database names.

Suggestion

Consider adding comments or documentation to explain the rationale behind bypassing the DSN "database" parameter and using the explicit "USE " statement. This will help future developers understand the context and reasoning behind this change, especially if they encounter similar issues. Additionally, ensure that any potential edge cases, such as special characters in database names, are handled appropriately.

_Disclaimer: This comment was entirely generated using AI. Be aware that the information provided may be incorrect._ Current plan usage: 8.87% **Have feedback or need help?** [Discord](https://discord.gg/r72ykfvyx7) [Documentation](https://docs.codeautopilot.com/) [support@codeautopilot.com](mailto:support@codeautopilot.com)